[dbo].[vSoaChangeLog]

SQLServer > iMIS1521GA > Views > dbo.vSoaChangeLog

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	3:38:39 PM Friday, January 07, 2011
Last Modified	1:49:25 PM Thursday, September 22, 2011

Columns

Name
ChangeLogId
IdentityEntityTypeName
IdentityIdentityElement
ChangeDate
Subtype
ChangedByUserId
LogText

SQL Script

CREATE VIEW [vSoaChangeLog]
AS
SELECT 'Party-' + [ID] +'-' + CONVERT(varchar, [DATE_TIME], 126) AS [ChangeLogId],
       'Party' AS [IdentityEntityTypeName],
       [ID] AS [IdentityIdentityElement],
       [DATE_TIME] AS [ChangeDate],
       [SUB_TYPE] AS [Subtype],
       [USER_ID] AS [ChangedByUserId],
       [LOG_TEXT] AS [LogText]
  FROM [Name_Log]

GO

Uses

[dbo].[Name_Log]
dbo